var sqlMap = {
    school: {
        // 更新感染人数
        updateInfected: 'UPDATE school SET Infected = ? WHERE SchoolName = ? ',
        // 查询感染等级和感染人数
        selectInfected: 'SELECT Infected FROM school where SchoolName = ? '
    },
    material: {
        // 更新剩余物资
        updateAllMaterial: 'UPDATE material SET Num = Num + ? WHERE Name = ? ',
        // 查询剩余物资
        selectAllMaterial: 'SELECT Num FROM material where Name = ? '
    },
    sch_ma: {
        // 更新物资分配
        updateMaterial: 'UPDATE sch_ma SET Num = Num + ? WHERE SchName = ? AND MaName = ? ',
        // 查询物资分配
        selectMaterial: 'SELECT Num FROM sch_ma WHERE SchName = ? AND MaName = ? '
    }
};

module.exports = sqlMap;
